Seeking Guidance on Granting 'Read' Access in Azure Synapse Serverless SQL Pool

Hello Azure Community,

I'm currently working on an Azure Synapse Analytics workspace project utilizing a serverless SQL pool. We rely on a SAS token to access our data stored in Azure Data Lake. This data is then presented within a Power Platform canvas app.

Our main objective is to allow an AAD group (or group) 'Read' access to the data within the serverless SQL pool. Despite my capacity as the service owner and numerous attempts at configuring permissions, I find myself unable to accomplish the desired access control. It's critical for us to strictly confine the specific user or group's access to 'Read' only operations to comply with our organization's stringent data security policies.

Despite my efforts, I'm unable to achieve the required configuration. Your insights and recommendations on this matter would be highly appreciated.

Looking forward to your valuable responses.

Best Regards,

Nicole